/*
 Navicat Premium Data Transfer

 Source Server         : 116.205.164.251
 Source Server Type    : MySQL
 Source Server Version : 50739 (5.7.39)
 Source Host           : 116.205.164.251:3306
 Source Schema         : zxw_gateway

 Target Server Type    : MySQL
 Target Server Version : 50739 (5.7.39)
 File Encoding         : 65001

 Date: 15/10/2022 23:03:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_gateway
-- ----------------------------
DROP TABLE IF EXISTS `t_gateway`;
CREATE TABLE `t_gateway` (
  `id` varchar(20) NOT NULL COMMENT '路由ID',
  `route_name` varchar(255) DEFAULT NULL COMMENT '路由名称',
  `route_pattern` varchar(255) DEFAULT NULL COMMENT '路由规则',
  `route_type` varchar(255) DEFAULT NULL COMMENT '路由类型',
  `route_url` varchar(255) DEFAULT NULL COMMENT '路由URL',
  `filters` varchar(255) DEFAULT NULL COMMENT 'Filters',
  `version` bigint(20) unsigned DEFAULT '1' COMMENT '乐观锁',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `status` varchar(20) DEFAULT '0' COMMENT '删除状态 : 1正常，0删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_gateway
-- ----------------------------
BEGIN;
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613366108161', 'user', '/api/v1/user/**', '0', 'zxw-user-server', '0', 1, '2022-05-24 20:47:19', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613378691012', 'link', '/api/v1/link/**', '0', 'zxw-article-server', '0', 1, '2022-05-24 20:47:19', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613378691022', 'notice', '/api/v1/notice/**', '0', 'zxw-article-server', '0', 1, '2022-05-24 20:47:19', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613378691023', 'tag', '/api/v1/tag/**', '0', 'zxw-article-server', '0', 1, '2022-05-24 20:47:19', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613378691073', 'auth', '/auth/**', '0', 'zxw-auth-server', '1', 1, '2022-05-24 20:47:19', '2022-10-14 16:04:55', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613378691074', 'order', '/order/**', '1', 'http://www.baidu.com', '0', 1, '2022-05-24 20:47:19', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1529081613378691075', 'article', '/api/v1/article/**', '0', 'zxw-article-server', '0', 1, '2022-05-24 20:47:19', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1534465760884436111', 'third', '/api/v1/third/**', '0', 'zxw-third-server', '0', 1, '2022-06-08 17:21:59', '2022-10-14 15:59:49', '1');
INSERT INTO `t_gateway` (`id`, `route_name`, `route_pattern`, `route_type`, `route_url`, `filters`, `version`, `create_time`, `update_time`, `status`) VALUES ('1534465760884436456', 'oauth', '/oauth/**', '0', 'zxw-auth-server', '0', 0, '2022-06-08 17:21:59', '2022-10-15 14:54:25', '1');
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime(6) NOT NULL COMMENT 'create datetime',
  `log_modified` datetime(6) NOT NULL COMMENT 'modify datetime',
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AT transaction mode undo table';

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
